﻿IF (EXISTS(SELECT id from sysobjects where id=object_id('usp_GetWards')))
	DROP PROCEDURE [dbo].[usp_GetWards]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

Create PROCEDURE [dbo].[usp_GetWards]
@PanchayatId as varchar(10)
AS
SET NOCOUNT ON;
select * from tblWard where PanchayatId=@PanchayatId